# 使用xlwings复制
from pathlib import Path
import xlwings as xw

app = xw.App(visible=False, add_book=False)

# Create two books and add a value to the first sheet of the first book
first_book = app.books.open("C:/Users/86150/Desktop/社保代缴/社保通账单.xlsx")
second_book = app.books.open("C:/Users/86150/Desktop/社保代缴/社保代缴信息.xlsx")

# Copy to second Book requires to use before or after
first_book.sheets[0].copy(after=second_book.sheets[0])

first_book.save()
first_book.close()

second_book.save()
second_book.close()
